SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE VIEW [dbo].[TRPRCL_USUA]
AS
SELECT 'P' AS TI_AUXI, CO_PROV AS CO_AUXI, CO_USUA 
FROM TRPROV_USUA
UNION ALL
SELECT 'C' AS TI_AUXI, CO_CLIE AS CO_AUXI, CO_USUA 
FROM TRCLIE_USUA
GO
